1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

mysql inner join limit 1 or grab the last (within one inner join)

Discussion in 'MySQL' started by xbat, Nov 29, 2018.

0
  1. #1
    I know this is not possible but this is what I want to do...

    inner join tabbble ON concat ( B.`planted`,'-',`withshovel`.`color`)=( tabbble.`entireshvoelcolor` AND tabbble.`Date` >= DATE_SUB(CURDATE(), INTERVAL 400 DAY) ORDER BY tabbble.`Date` DESC limit 1 )

    I did try a sub query but
    inner join tabbble ON concat ( B.`planted`,'-',`withshovel`.`color`)=(sub query) - but I need it to match up with concat ( B.`planted`,'-',`withshovel`.`color`)

    thanks
     
    xbat, Nov 29, 2018 IP