Member Avatar for ms061210
ms061210 0 Light Poster

Hello! I want to add query to report viewer, but i don't know how. I can't find a tutorial that does what I need so please help me po. I want to fill the data tables or report viewer of datas coming from different tables.

Here is my sql code:

SELECT ten.tenant_id, ten.last_name, ten.first_name, ren.date_to, ren.date_from, pay.date_paid, pay.amount, pay.balance
FROM tenant ten INNER JOIN rental ren
ON ten.tenant_id = ren.tenant_id
INNER JOIN payment pay
ON ren.rental_number = pay.rental_number

Please help me.

  • 1 Contributor
  • 0 Replies
  • 83 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.