How to do join query in laravel?

Sql query to show if 30days have gone by a members join date?

• I want to create a query to show only members which have been members for more than 30days, i have already made a query to show: SELECT Members.FirstName, Members.LastName, Subscription.SubscriptionID, Subscription.SubscriptionType FROM Members INNER JOIN Subscription ON Members.MemberID = Subscription.MemberID So i need to somehow calculate if 30days have gone by a since the members membership date till today's date.

• Answer:

  you will need to use the DATAADD function.. Let's say you have the Subscription Date as Subscription.SubscriptionDate, then you can do: SELECT Members.FirstName, Members.LastName, Subscription.SubscriptionID, Subscription.SubscriptionType FROM Members INNER JOIN Subscription ON Members.MemberID = Subscription.MemberID WHERE date < DATEADD(day, -30, GETDATE()) I am not sure of the exact syntax above but i am sure you can get what you are after with the DATAADD function