Need some help....
10 views
Skip to first unread message
Anthony DeSalvatore
Sep 20, 2012, 6:52:27 PM9/20/12
to dat...@googlegroups.com
I need some help, been trying to figure this one out for hours...
SELECT c.CaseCode
FROM cse c
INNER JOIN cse_user cu
ON c.id = cu.cid
WHERE cu.idUser = 1
AND cu.dt IS NULL
Is this possible, or do I need to pass the sql on? I hope this is still being monitored, I see there has not been a post in a while...
SELECT c.CaseCode
FROM cse c
INNER JOIN cse_user cu
ON c.id = cu.cid
WHERE cu.idUser = 1
AND cu.dt IS NULL
Is this possible, or do I need to pass the sql on? I hope this is still being monitored, I see there has not been a post in a while...
Steve Bryant
Sep 24, 2012, 10:31:14 AM9/24/12
to dat...@googlegroups.com
I'm not quite following your issue. If you want a field with those restrictions then you might try a filter in your relation field. If you actually need a join then that will have to be sql. Let me know.
--
You received this message because you are subscribed to the Google Groups "DataMgr" group.
To view this discussion on the web visit https://groups.google.com/d/msg/datamgr/-/YaWR2x1eDksJ.
To post to this group, send email to dat...@googlegroups.com.
To unsubscribe from this group, send email to datamgr+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/datamgr?hl=en.
Reply all
Reply to author
Forward
0 new messages