Select & Where Clause in RS2005

• Toni Chaffin

  SSCommitted

  Points: 1513

  More actions

  May 22, 2006 at 3:22 am

  #115212

  Is it possible in RS 2005 to have linked fields on a report. I have one dataset that contains one section on information, I then have a seperate dataset which contains some different information.

  site_ref is the common link between the two datasets. I will write the sort of syntax I would expect to see in plain english and then perhaps someone could point me in a direction of the correct syntax to use if it is possible to do

  The following Assumptions made, two datasets containing a link on site_ref

  result textbox = show dataset2.budgetnetrent where dataset1.site_ref = dataset2.site_ref

  Does that make sense?

  Regards

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  May 22, 2006 at 3:33 am

  #639180

  select table1.*,table2.* from table1 inner join table2 on table1.site_ref=table2.site_ref

  MVDBA