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 |