Hi,
I should know this. But I don't. obviously.
Can anyone help me?
I have a table called tbl_customerquery which, amongst others, has three foreign keys queryconid, querycatid and querytypeid which link to the tables querycon, querycat and querytype respectively.
The thing is there is only one entry in querycon so when I run a query based on the above tables I only get one row returned.
Is there a way of outputting all 54 rows that should be returned that have a "0" in the "querycon" table?
Did any of that make sense?
It didn't to me.
I should know this. But I don't. obviously.
Can anyone help me?
I have a table called tbl_customerquery which, amongst others, has three foreign keys queryconid, querycatid and querytypeid which link to the tables querycon, querycat and querytype respectively.
The thing is there is only one entry in querycon so when I run a query based on the above tables I only get one row returned.
Is there a way of outputting all 54 rows that should be returned that have a "0" in the "querycon" table?
Did any of that make sense?
It didn't to me.