CODEWITHSUNDEEP
mysqlsqlselect
cce85899
cce85899

Reputation: 29

Select days from schedule

So I made this code :

SELECT 
    day.weekday
FROM
    day,
    event,
    event_date
WHERE
    EXISTS( SELECT 
            day.weekday
        FROM
            day)
        AND event.event_id = event_date.event_id
        AND event.day= day.day
GROUP BY day.weekday

It's working , but is there any other way to do it with EXSISTS ?

Upvotes: 2

Views: 52

Answers (1)

Clément Prévost
Clément Prévost

Reputation: 8600

Try this

SELECT 
    day.weekday
FROM
    day
    JOIN event ON event.day= day.day
    JOIN event_date ON event.event_id = event_date.event_id
GROUP BY 
    day.weekday

Upvotes: 3

Related Questions