Jump to content

Archived

This topic is now archived and is closed to further replies.

phporcaffeine

mysql SELECT Query help

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.