Hi Peter,
>Is there possible to do this SQL select?
>
>SELECT * FROM Foretag_T, Kommun_T, Postort_T
>WHERE ForetagsID > 0
>AND ( LEFT (Kommun_T.Kommun,5) = 'stock' OR LEFT (Postort_T.Postort,5)
>= 'stock' )
>
known issue...
'or' don't work between different tables
Cool Runnings,
Erne.
©2002 erne |
