Re: Left Join

Maybe it's just me, but I can't see anything that would work as foreign key for you to join on - neither table seems to have a foreign key On 7 August 2011 21:53, Chris Stinemetz <chrisstinemetz@gmail.com> wrote: > I am tyring to build a query that will take the most recent > "stores.store_date" column then join it with "store_list.store_name" where > store_list.store_name and > stores.store_subject match then return the most recent "stores.store_date". > I am guessing this will require some sort of join. I have been tyring to > figure it > out but have had no luck. > Any help is greatly apprciated. > Thank you. > > mysql> select * from stores; > > +----------+-----------------+------------+---------------------+-----------+----------+-----------------+-------------- > -----------+ > | store_id | store_subject   | store_type | store_date          | store_mar > | store_by | store_tptest    | store_comment > s          | > > +----------+-----------------+------------+---------------------+-----------+----------+-----------------+-------------- > -----------+ > |       78 | Bella Roe       | corporate  | 2011-06-28 15:01:02 |         0 > |        1 |                 | >          | > |       79 | Bella           | corporate  | 2011-08-06 08:48:26 |         0 > |        1 | 600kbps-3.8mbps | test >          | > |       80 | Brittney~2120   | corporate  | 2011-08-06 08:48:50 |         1 > |        1 | 600kbps-3.8mbps | should post t > o Wichita! | > |       81 | Motor           | premier    | 2011-08-06 14:52:55 |         1 > |        1 | 600kbps-3.8mbps | test >          | > |       82 | Liberty         | corporate  | 2011-08-06 14:54:41 |         0 > |        1 | 0-250kbps       | test >          | > |       83 | Seneca~3165     | corporate  | 2011-08-06 14:58:47 |         0 > |        1 | 600kbps-3.8mbps | test >          | > |       84 | Liberty         | corporate  | 2011-08-06 14:59:32 |         0 > |        1 | 400-600kbps     | test >          | > |       85 | Brittney~2120   | corporate  | 2011-08-06 15:00:43 |         0 > |        1 | 600kbps-3.8mbps | test >          | > |       86 | Liberty         | corporate  | 2011-08-06 15:01:11 |         0 > |        1 | 300-400kbps     | test >          | > |       87 | Brittney~2120   | corporate  | 2011-08-06 15:11:06 |         0 > |        1 | 250-300kbps     | test >          | > |       88 | Brittney~2120   | corporate  | 2011-08-06 15:23:53 |         1 > |        1 | 600kbps-3.8mbps | test >          | > |       89 | Bella           | corporate  | 2011-08-06 15:31:49 |         0 > |        1 | 600kbps-3.8mbps | test >          | > |       90 | Cleartalk~10221 | premier    | 2011-08-06 15:32:54 |         0 > |        1 | 250-300kbps     | test >          | > |       91 | Chit            | premier    | 2011-08-06 15:33:50 |         1 > |        1 | 250-300kbps     | test >          | > |       92 |                 |            | 2011-08-06 15:34:21 |         > 2 > |        1 | 300-400kbps     | test >          | > |       93 | Bella           | corporate  | 2011-08-07 11:26:13 |         0 > |        1 | 600kbps-3.8mbps | test >          | > > +----------+-----------------+------------+---------------------+-----------+----------+-----------------+-------------- > -----------+ > 16 rows in set (0.00 sec) > mysql> > > mysql> select * from store_list LIMIT 15;' > > +----+---------------+----------------------------------------+------------+-------------+-----------+ > | id | market_prefix | store_name                             | store_type | > market_name | id_market | > > +----+---------------+----------------------------------------+------------+-------------+-----------+ > |  1 | MCI           | Bella Roe~4980 Roe Blvd                | Corporate  | > Kansas City |         0 | > |  2 | MCI           | Cleartalk~4635 Shawnee Dr              | Premier    | > Kansas City |         0 | > |  3 | MCI           | Cleartalk~3612 State Avenue            | Premier    | > Kansas City |         0 | > |  4 | MCI           | Endless Wireless~1620 Central Avenue   | Premier    | > Kansas City |         0 | > |  5 | MCI           | Get Wireless~840 Minnesota             | Premier    | > Kansas City |         0 | > |  6 | MCI           | Ring Ring Wireless~7559 State Avenue   | Premier    | > Kansas City |         0 | > |  7 | MCI           | Cleartalk~1212 Sante Fe                | Premier    | > Kansas City |         0 | > |  8 | MCI           | Cleartalk~10221 W 75th Street          | Premier    | > Kansas City |         0 | > |  9 | MCI           | Free Talk~10830 Shawnee Mission Pkwy   | Premier    | > Kansas City |         0 | > | 10 | MCI           | Loma Vista~8712 Blue Ridge Blvd        | Corporate  | > Kansas City |         0 | > | 11 | MCI           | Ring Ring Wireless~25 W. 39th Street   | Premier    | > Kansas City |         0 | > | 12 | MCI           | Ring Ring Wireless~3039 Prospect Ave   | Premier    | > Kansas City |         0 | > | 13 | MCI           | Ring Ring Wireless~1201 E Linwood Blvd | Premier    | > Kansas City |         0 | > | 14 | MCI           | Ring Ring Wireless~4314 Rainbow Blvd   | Premier    | > Kansas City |         0 | > | 15 | MCI           | Ring Ring Wireless~7445 Prospect Ave.  | Premier    | > Kansas City |         0 | > > +----+---------------+----------------------------------------+------------+-------------+-----------+ > 15 rows in set (0.00 sec) > -- <hype> WWW: plphp.dk / plind.dk LinkedIn: plind BeWelcome/Couchsurfing: Fake51 Twitter: kafe15 </hype>