"beejayzed" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have two tables, one which has each visit(call) on a house logged, > another which has each letter sent to a house logged. > I would like to create a query which has two columns, Letters.Date and > Calls.Date, for a specific HouseID.
What for? Why do you want to put two completely unrelated values into the same row? This makes no sense from relational calculus standpoint, and that's why you have a hard time expressing such a beast in SQL. What are you trying to achieve? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users