CodingForums.com - View Single Post

Justin Ba · 06-20-2002, 11:49 PM

SELECT DISTINCT
a.field1, c.field2, a.field3, left(d.field4,15)
FROM tbl_Table1 a
LEFT JOIN tbl_Table2_R c ON a.field1 = c.FKField1
LEFT JOIN tbl_Table3_R d ON a.Field1= d.FKField1
WHERE 1=1
AND a.field3= 'text' ORDER BY a.field3, a.field1

Same problem

any more ideas?

06-20-2002, 11:49 PM	PM User \| #2
Justin Ba New Coder Join Date: Jun 2002 Posts: 19 Thanks: 0 Thanked 0 Times in 0 Posts	SELECT DISTINCT a.field1, c.field2, a.field3, left(d.field4,15) FROM tbl_Table1 a LEFT JOIN tbl_Table2_R c ON a.field1 = c.FKField1 LEFT JOIN tbl_Table3_R d ON a.Field1= d.FKField1 WHERE 1=1 AND a.field3= 'text' ORDER BY a.field3, a.field1 Same problem any more ideas?