"OR" Statement using Data Model

[kbrownnd97]

Hi,

I would like to use the data model to create a selection like this:

SELECT TableA.*, TableB.*
FROM TableA A, TableB B
WHERE A.FIELD1 = B.FIELD1
OR A.FIELD1 = B.FIELD2

Can anyone explain how to create this? It's basically a simple "OR" statement, but I'm struggling with how to create this in the Data Model Editor.

Thanks for your help!
- KBrown

[nikkil]

Hi kbrownnd97, it's been a while already but have you found any work around on this?
_________________
You're never a loser until you quit trying.