constructing SQL problem

2003-07-10 Thread Krasimir_Slaveykov
Hello , I have a problem with constructing correct SQL. I have tables: TABLE1 wich have FIELD1 and FIELD2 TABLE2 wich have FIELD1 and FIELD2 TABLE3 wich have FIELD1, FIELD2 and FIELD3 I have this SQL: select a.field1, a.field2,

RE: constructing SQL problem

2003-07-10 Thread Rudy Metzger
: constructing SQL problem Hello , I have a problem with constructing correct SQL. I have tables: TABLE1 wich have FIELD1 and FIELD2 TABLE2 wich have FIELD1 and FIELD2 TABLE3 wich have FIELD1, FIELD2 and FIELD3 I have this SQL: select