RE: [development-axapta] Help: SQL Syntax

[Morten Aasheim]

Do you want to use this information on a form?



You can use QueryBuildDatasource to join tables:



queryBuildDataSource.joinMode(JoinMode::OuterJoin);

queryBuildDataSource.fetchMode(QueryFetchMode::One2One);

queryBuildDataSource.addLink(fieldNum(table, field), fieldNum(table2, field2));



You can also join tables in a select:



           while select table

           join table 2

           where table.field = table2.field2





Hope this will help..





Morten

 _____  

From: vozadali [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 11, 2003 12:50 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Help: SQL Syntax



I want to show courses which, say TJO, didn't registered on a grid. 

In "HRMCourseTable" there is "hrmCourseID" field. This table gives 
information about the courses

In "HRMCourseAttendee" table there is "hrmCourseID" 
and "hrmVirtualNetworkId" field. This table shows which employee took 
which course.

As far as I know Axapta doesn't allow two select statement in one 
query. How can I do this operation using selects or querybuildrange ?

Thankx





Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 

Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.