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?

Edited November 6, 2013 by Barand

[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

Edited November 6, 2013 by rwrogers

[Barand]

Is there and attorneyid in the attorney positions table?