mysql SELECT Query help

[phporcaffeine]

2 tables, 1 database

Database: 'breakdown'

Table 1: record

Table 2: notify


    When record is inserted into table 'record' an entry is made in table 'notify', with table 'record' 's auto?_number.

    I want to SELECT FROM record WHERE col='mydata' AND FROM notify WHERE col='mydata'.  I know that isn't the right syntax but hopefully you get what I am tryig to do.  I am trying to select a row based on a single value existing in 2 different columns, in 2 different tables.


TIA

[ShogunWarrior]

SELECT * FROM record LEFT JOIN notify ON notify.col = record.col WHERE record.col = 'mydata';