Search results

To keep things simple, I have got a db and that has 10+ ref tables, and i need to show everything from those tables in one, and these tables includes Attachment field. I have tried union but did not help. How can i achieve this? EDIT: i may have posted in wrong section.

Alright everyone, please take it easy on me not advance user here. I have a master table, and search form. Trying to search for specific things using the form from table. I decided to create a query with specific number, or job number or size. And so far if i specify before searching i get that...