[SQL] Finding all tables that have foreign keys referencing a table

Hi. I see the last comment here suggests a solution for $subject: http://www.postgresql.org/docs/8.1/interactive/ddl-constraints.html But it turns out it assumes constraint_name is unique, which is not the case. It is only unique pr. table. In other words, it produces a lot of false results. I'm

Re: [SQL] need help in building a query

I personally would help if I understood what you need. I'm sure others feel the same way. Provide DDL, sample data, and expected result of the query. Maybe you'll have better luck... On Thu, Nov 6, 2008 at 11:15 AM, Devil™ Dhuvader <[EMAIL PROTECTED]>wrote: > none can help me? > > On Tue, Nov 4,

Re: [SQL] need help in building a query

none can help me? On Tue, Nov 4, 2008 at 9:08 PM, Devil™ Dhuvader <[EMAIL PROTECTED]> wrote: > hi, > I need some help in creating a sql. > the problem is as below. > > assume that: > I am a store keeper > and I have the list of customer(user_id) transactions in my order table. > schema: Orders(or