Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Postgress problem
Sorry to bother you with Postgress problem in ANSI-SQL forum, but I didn't find any good postgress forum, so i hope someone here is able to help me. I have problem with with NULLs. My problem is as follows: I have for example this table: id | timestamps --------------- 1 | 9999343... -
joining views
i have 2 views p1v,p2v select * from p1v; id1 | count1 -----+-------- 1 | 2 2 | 1 (2 rows) select * from p2v; id2 | count2 -----+-------- 1 | 1 2 | 1 (2 rows) is it possible to join views ? i have incorrect results(see bellow. 2's in the column count2 ) how... -
select problem (is it possible?)
i have four tables: Table 1.)info_firm ------------------------ id | name | class_id | ------------------------ 1 | CNN | 1000 | 2 | MTV | 1000 | 3 | Radio1 | 1001 | FK class_id references info_class(id) Table 2.)info_class ------------------- id | name |...
