1. Home
  2. LLBLGen Pro
  3. Architecture

HOW CAN I DO LIKE THIS SQL

Posts   
 
    
heyu52
User
Posts: 21
Joined: 27-Apr-2010
# Posted on: 19-Oct-2010 10:57:31   

SELECT A . DESCRPRTION ,B.ITEM_TYPE FROM

LOT A INNER JOIN STOCK B ON A.COM_ID = B.COM_ID AND A.ITEM_CODE = B.ITEM_CODE AND B.USESERIAL = 0 where a.com_id = 'ASC' and A.QTY_UNIT <> 0

Walaa avatar
Walaa
Support Team
Posts: 14983
Joined: 21-Aug-2005
# Posted on: 19-Oct-2010 11:10:34   

Use a DynamicList. And add customFilter to the relation(Join) used.

heyu52
User
Posts: 21
Joined: 27-Apr-2010
# Posted on: 19-Oct-2010 11:21:45   

can you give me example

Walaa avatar
Walaa
Support Team
Posts: 14983
Joined: 21-Aug-2005
# Posted on: 19-Oct-2010 11:39:00   

Please follow the code examples found in the docs (check the links I've posted). And if you need further assistance, post your code, and explain what's been going wrong.