View not displaying expected records
Hello All,
I have a feeling I ask too many questions but I really do appreciate all the help.
I have created a view and when I un-comment the below section and just run the Select part, I get the expected results, for any SO I choose. When I comment out the testing order_number and create the view, when I describe the view and look at the data, I only get the first record ever created.
I am looking for the first row of every order_number.
CREATE OR REPLACE VIEW apps.xxprk_shipments_v (
ordered_date,
signed,
mm,
I have a feeling I ask too many questions but I really do appreciate all the help.
I have created a view and when I un-comment the below section and just run the Select part, I get the expected results, for any SO I choose. When I comment out the testing order_number and create the view, when I describe the view and look at the data, I only get the first record ever created.
I am looking for the first row of every order_number.
CREATE OR REPLACE VIEW apps.xxprk_shipments_v (
ordered_date,
signed,
mm,
0