Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > LLBLGen Pro Runtime Framework> joining on unrelated tables
 

Pages: 1
LLBLGen Pro Runtime Framework
joining on unrelated tables
Page:1/1 

  Print all messages in this thread  
Poster Message
bonder
User



Location:

Joined on:
23-Sep-2003 05:05:17
Posted:
36 posts
# Posted on: 07-Feb-2006 02:32:50.  
I have a situation where I want to code a query for a dynamic list that replicates the following SQL query:

select
Table1ID
from
Table1ID
join
Table2 on Table1.Table1ID = Table2.Table1ID
join
Table3 on Table1.TypeCode = Table3.TypeCode
where
...(some filter stuff hidden)

The problem is the join between Table1 and Table3. TypeCode is NOT a primary key or foreign key on either table. It is, in fact, the worst of all possible joins -- no formal constraint between tables, and these columns are varchars.

This problem will be fixed in future versions of the system, but for now I have to support this mess.

Is this easily done in LLBLGen Pro querying?

--Bruce


UPDATE: I figured out how to add an entityrelation manually! Regular Smiley
  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.