Sql help needed, basic query help

[mattastic]

I have the following tables.

events:

id (pk), title, start, end, userid (FK from members)

Members:

id (pk), username, password, fullname.

Could you please tell me how I can query all events and user details for each member?

[Ashley_Sheridan]

To query all events:

SELECT * FROM events;

To select all user details for each member:

SELECT * FROM Members

However, I don't think that what you asked was what you wanted, did you perhaps want to JOIN the tables on the foreign key? That would be something like this:

SELECT e.id AS event_id, e.title, e.start, e.end, m.id AS user_id, m.username, m.password, m.fullname
FROM events
LEFT JOIN Members m on m.id = e.userid