Subject | In Firebird what table contains the email address? |
---|---|
Author | kissthegirlsandmakethemcry |
Post date | 2012-04-26T17:42:41Z |
In Firebird what table contains the email address?
I'm currently do a select statement, but I can't seem to find the email address.
Here is my current select statement:
SELECT so.id, so.num AS sonumber, so.customercontact, so.shiptoname, so.shiptoaddress, so.shiptocity, so.cost, stateconst.code, so.shiptozip, countryconst.abbreviation, carrier.name,carrier.description,shipcarton.freightweight, shipcarton.id as shipcartionid, shipcarton.cartonnum, customercontactview.contactnum FROM so
LEFT JOIN countryconst ON so.shiptocountryid = countryconst.id
LEFT JOIN stateconst ON so.shiptostateid=stateconst.id
LEFT JOIN carrier ON so.carrierid = carrier.id
LEFT JOIN shipcarton ON so.id = shipcarton.orderid
LEFT JOIN customercontactview ON so.customerid=customercontactview.custid
WHERE so.num='$ORDERNUMBER'
I've looked in various tables and cannot seem to find it.
Any help would be greatly appreciated!!
I'm currently do a select statement, but I can't seem to find the email address.
Here is my current select statement:
SELECT so.id, so.num AS sonumber, so.customercontact, so.shiptoname, so.shiptoaddress, so.shiptocity, so.cost, stateconst.code, so.shiptozip, countryconst.abbreviation, carrier.name,carrier.description,shipcarton.freightweight, shipcarton.id as shipcartionid, shipcarton.cartonnum, customercontactview.contactnum FROM so
LEFT JOIN countryconst ON so.shiptocountryid = countryconst.id
LEFT JOIN stateconst ON so.shiptostateid=stateconst.id
LEFT JOIN carrier ON so.carrierid = carrier.id
LEFT JOIN shipcarton ON so.id = shipcarton.orderid
LEFT JOIN customercontactview ON so.customerid=customercontactview.custid
WHERE so.num='$ORDERNUMBER'
I've looked in various tables and cannot seem to find it.
Any help would be greatly appreciated!!