newbie question on query

[rwrogers]

I'm trying to setup a form where users can search using one or more fields, such as firstname, lastname, office.

 

However, the info is coming from multiple tables.  Here is the query I have so far, I've gotten rid of the errors, but now it doesn't return any rows.

 

SELECT   

A.firstname,  

A.lastName,  

O.Name, 

R.Position 

 

FROM  

AttorneyData A, 

Offices O, 

AttorneyPositions R 

 

WHERE  

O.id='2'

AND     R.Position='3'

AND A.firstName='Test'

AND A.lastName='User'

;

 

Any ideas would be greatly appreciated.

 

Richard

[Barand]

Table structure?

 

How are those three tables related?

[rwrogers]

Well no relationship set, like I would like.

 

In the AttorneyData table, there is an "Office" id that is the same as the "id" in the Offices table

 

 

php 5.4.12

mysql  5.6.12

Richard

[Barand]

Is there and attorneyid in the attorney positions table?