main logo
Subject: SQL problem
Author: Peter Lundb{ck
Posted: 2002/08/29 09:35:33
 
View Entire Thread
New Search


Hi!

Is there possible to do this SQL select?

SELECT * FROM Foretag_T, Kommun_T, Postort_T
WHERE ForetagsID > 0=20
AND ( LEFT (Kommun_T.Kommun,5) =3D 'stock' OR LEFT (Postort_T.Postort=
,5) =20
=3D 'stock' )


I never seems to get the OR inside the AND to work (it's always AND),
in other words, i only get the post where Kommun and Postort is equal.
Both fields are VarChar.

[VSDK] - [Win32] - [Win2kSwe]

Best regards
Peter Lundb=E4ck
 
©2002 Peter Lundb{ck
<-- Prior Message New Search Next Message -->