Viewing 15 posts - 61 through 75 (of 152 total)
As...
June 14, 2017 at 1:32 pm
I know why its failing, I will repost
June 14, 2017 at 1:29 pm
My current query:SELECT
Ticket.i_ticket_id as Ticket#,
TicketItem.s_item as Menu_Item,
ChoiceItem.s_choice_name as Choice_Added,
TicketItem.s_qty as Quanity_Sold,
ChoiceItem.i_ticket_item_id as Ticket_Item_ID,
Customers.cust_fullname as Customer,
Employees.s_name as...
June 14, 2017 at 12:43 pm
Here are the 5 Tables with some sample data, taken directly from the database.
This Query, works, but it shoes redundant data I need omitted. IF there is...
June 14, 2017 at 12:40 pm
June 14, 2017 at 8:50 am
Anyone? Please I have a deadline in 36hrs 🙁
June 13, 2017 at 6:33 pm
Will this work?? So if I do this for the 5 tables, this will get you what you need to assist?
CREATE TABLE Ticket(
i_ticket_id ...
June 13, 2017 at 11:22 am
For the table definitions, you can just...
June 6, 2017 at 2:39 pm
June 6, 2017 at 2:14 pm
June 6, 2017 at 2:13 pm
June 6, 2017 at 1:56 pm
June 6, 2017 at 1:13 pm
June 6, 2017 at 12:20 pm
pietlinden - Tuesday, June 6, 2017 12:03 AMCan't run a SQL statement against a picture. If you want help, provide consumable data.
I...
June 6, 2017 at 11:17 am
I was thinking in my head, an IF statement as well..something like..
IF RowNumber > 1 and Ticket.i_ticket_id are =, and TicketItem.s_item are =, and ChoiceItem.i_ticket_item_id are = then only...
June 5, 2017 at 8:42 pm
Viewing 15 posts - 61 through 75 (of 152 total)