Select * from orders LEFT OUTER JOIN gift_cards on orders.order_number = gift_cards.order_numberWHERE orders.order_number = @ARG orders_uid1Looking at your query, you are only requesting cols from orders table, and the criteria is only from orders table. So why the join? Am I missing something?I
We use easymail objects. http://www.quiksoft.com/objects/
It is an inexpensive COM that is really
reliable and easy to integrate with.
We generate the emails dynamically in
Witango and push them to the object.
Just don't create the object in local
scope over and over again or you
Sorry, I didn't read the whole message.
You are looking to read and generate
emails, store the component of the message in a db and have a process that gets
and sends out emails on a timely basis?
p.
From: Peter Dobbs
[mailto:[EMAIL PROTECTED]
Sent: Sunday, November 20,
selecting all from the join gets all the column in both tables the left outer join is that sometimes the second table doesn't have a matching row.On Nov 20, 2005, at 1:10 AM, Robert Garcia wrote:Select * from orders LEFT OUTER JOIN gift_cards on orders.order_number = gift_cards.order_numberWHERE
Yeah, sound like a good
idea using Witango as email parser, save them in a db and create a Witango app
for searching the db.
Thanks Robert I will look in to it. It will mean a possibility to create a
talklist even for external mailing lists,
/Bengt
Från:
Robert Shubert
ok, in the past, I have gotten errors that way, I would usually do something more likeselect orders.*,gift_cards.* Don't know if that will make a difference, but I would definitely try ANSI syntax.select o.*, gc.* from orders o, gift_cards gc WHERE (o.order_number *= gc.order_number) AND
Just figured id forward this to all of you.
My wife and I just had a baby Thursday night and I went to
look at my babys picture on their website.
Well it seems the hospital has used witango for their site.
http://www.riddlehospital.org/default1.taf?focus=NMEN301Z
Just thought