Hello everyone,
I have 2 tables I am trying to query:
transactions and tasks
they each have a column name "requestid"
I am trying to query the db with the following statement:
select * from transactions,tasks
where transactions.requestid = tasks.requestid
and transactions.requestid = $requestid
and tasks.requestid = $requestid
order by transactions.id asc
This does get the data I want, but I always get 3 copies of each record. Why? I know I'm missing something here, but I've tried everything: left join, inner join, etc.
Please help and thanks in advance
I have 2 tables I am trying to query:
transactions and tasks
they each have a column name "requestid"
I am trying to query the db with the following statement:
select * from transactions,tasks
where transactions.requestid = tasks.requestid
and transactions.requestid = $requestid
and tasks.requestid = $requestid
order by transactions.id asc
This does get the data I want, but I always get 3 copies of each record. Why? I know I'm missing something here, but I've tried everything: left join, inner join, etc.
Please help and thanks in advance