Join two mysql tables in a query?

DateDiff(date1, date2) returns the difference between these two dates in days.

Select * from myMembers m, accountOptions o where u. Notification='yes' AND m. Id = o.

Uid AND AND DATEDIFF(Now(), m. Last_logged_date) > 14 DateDiff(date1, date2) returns the difference between these two dates in days. dev.mysql.com/doc/refman/5.5/en/date-and....

Assuming id as the reference select aO. Id, aO. Uid, m.

Last_logged_date from accountOptions aO inner join myMembers m on aO. Id = m. Id where m.

Last_logged_date 14 and notification1 = 'yes.

SELECT myMembers. Last_logged_date, accountOptions. Notification1 FROM myMembers INNER JOIN accountOptions ON myMembers.

P_Id=accountOptions. Uid ORDER BY myMembers.id.

Use this query to join 2 tables SELECT * FROM myMembers,accountOptions WHERE myMembers. Id = accountOptions. Uid AND id=1; This will return the exact result.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions