Yes,. that doesn't return anything?
But I'll explain to you what im trying to do (If you dont mind)
I have a COMPANY table which holds info about a company, whose primary key is C_ID. Then I have an ACTIVITY table which holds info about an activity, whose primary key is A_ID and its foreign key (C_NUMBER) which links it to a company. I'm trying to perform a select by date function, so that once a certain date is selected, all the activity info and their coresponding company info would be listed.
Thank you soo much for helping me with this.